package com.xs.business.user.service;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;

import com.alibaba.fastjson.JSON;
import com.xs.mvc.common.HttpUtils;

/**
 * @Title: <P>Main.java</P>
 * @Package <P>com.xs.business.user.service</P>
 * @Description: <P>TODO该类...</P>
 * @author renweiping
 * @date 2019年3月1日 上午11:45:39
 * @version 1.0
 */

public class Main {
	private static final Logger LOG = Logger.getLogger(Main.class);

	/**
	 * @Description: TODO
	 * @param @param args   
	 * @return void  
	 * @throws
	 * @author renweiping
	  *@e_mail renweiping_1113@google.com
	 * @date 2019年3月1日
	 */

	public static void main(String[] args) {
		

	        //请求参数
	        String data = "{\"caseInfo\":{\"catalog\":{\"id\":\"1001\"},\"name\":\"t\",\"keywords\":\"t\",\"selectedIds\":[\"2c9083ee67beea1d0167bf37f6fd073e\"],\"adate\":\"201901\",\"cycle\":\"MONTH\",\"currentId\":1551409526597,\"root\":{\"presentId\":\"2c9083ee67beea1d0167bf37f700074e\",\"temp\":1551409526597,\"entity\":{\"refId\":\"2c9083ee67beea1d0167bf37f6fd073e\",\"analysises\":[{\"id\":\"2c9083ee67beea1d0167bf37f700074e\",\"fixedId\":\"2c9083ee67beea1d0167bf37f700074e\",\"order\":\"0\",\"primary\":{\"id\":\"2c9083ee67beea1d0167bf37f6fd0740\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"ff8080815f0047d2015f0537357b013a\",\"name\":\"MSISDN\",\"label\":\"MSISDN\",\"labelUS\":\"MSISDN\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},\"calendarField\":{\"id\":\"2c9083ee67beea1d0167bf37f6fe0742\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"ff8080815f0047d2015f0537056d0139\",\"name\":\"STARTTIME\",\"label\":\"STARTTIME\",\"labelUS\":\"STARTTIME\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},\"mcsetting\":\"images/chartTypes/Best_Campaign_Time_Window.png\",\"secondFilters\":[{\"order\":\"1\",\"location\":\"SETTING\",\"filterInfos\":[{\"order\":\"0\",\"type\":\"BASE\",\"style\":\"SEGMENTATION\",\"actionScope\":\"ALL\",\"processMode\":\"CASEWHEN\",\"show\":\"true\",\"mark\":\"Satisfy condition\",\"items\":[{\"order\":\"1\",\"itemType\":\"EXPLAIN\",\"manageStyle\":\"NOTES\",\"independent\":\"false\",\"id\":\"2c9083ee67beea1d0167bf3b78d70791\"},{\"order\":\"0\",\"defaultValue\":\"Traffic 234G\",\"value\":\"Traffic 234G\",\"itemType\":\"LABEL\",\"manageStyle\":\"TITLE\",\"independent\":\"false\",\"id\":\"2c9083ee67beea1d0167bf3b78d70792\"}],\"children\":[{\"order\":\"0\",\"show\":\"true\",\"items\":[{\"order\":\"5\",\"defaultValue\":\"MB\",\"value\":\"MB\",\"itemType\":\"SELECT\",\"manageStyle\":\"UNIT\",\"independent\":\"false\",\"options\":[{\"key\":\"MB\",\"value\":\"1\",\"order\":\"0\",\"show\":\"true\",\"name\":\"MB\",\"formula\":\"${value}*1\",\"id\":\"2c9083ee67beea1d0167bf3b78d50787\"}],\"id\":\"2c9083ee67beea1d0167bf3b78d50786\"},{\"order\":\"4\",\"name\":\"lpk249\",\"value\":\"0\",\"itemType\":\"TEXT\",\"manageStyle\":\"VALUE\",\"independent\":\"false\",\"id\":\"2c9083ee67beea1d0167bf3b78d50785\"},{\"order\":\"3\",\"defaultValue\":\"~\",\"value\":\"~\",\"itemType\":\"LABEL\",\"manageStyle\":\"NAME\",\"independent\":\"false\",\"id\":\"2c9083ee67beea1d0167bf3b78d60788\"},{\"order\":\"2\",\"defaultValue\":\"MB\",\"value\":\"MB\",\"itemType\":\"SELECT\",\"manageStyle\":\"UNIT\",\"independent\":\"false\",\"options\":[{\"key\":\"MB\",\"value\":\"1\",\"order\":\"0\",\"show\":\"true\",\"name\":\"MB\",\"formula\":\"${value}*1\",\"id\":\"2c9083ee67beea1d0167bf3b78d6078a\"}],\"id\":\"2c9083ee67beea1d0167bf3b78d60789\"},{\"order\":\"1\",\"offset\":\"0\",\"limit\":\"100\",\"defaultValue\":\"0\",\"name\":\"qsz090\",\"value\":\"0\",\"rawValue\":\"0\",\"itemType\":\"TEXT\",\"manageStyle\":\"VALUE\",\"independent\":\"false\",\"id\":\"2c9083ee67beea1d0167bf3b78d6078b\"}],\"id\":\"2c9083ee67beea1d0167bf3b78d50784\"},{\"order\":\"1\",\"show\":\"true\",\"items\":[{\"order\":\"4\",\"offset\":\"0\",\"limit\":\"102400\",\"defaultValue\":\"0\",\"name\":\"sjz882\",\"value\":\"0\",\"rawValue\":\"0\",\"itemType\":\"TEXT\",\"manageStyle\":\"VALUE\",\"independent\":\"false\",\"id\":\"2c9083ee67beea1d0167bf3b78d70790\"},{\"order\":\"5\",\"defaultValue\":\"MB\",\"value\":\"MB\",\"itemType\":\"SELECT\",\"manageStyle\":\"UNIT\",\"independent\":\"false\",\"options\":[{\"key\":\"MB\",\"value\":\"1\",\"order\":\"0\",\"show\":\"true\",\"name\":\"MB\",\"formula\":\"${value}*1\",\"id\":\"2c9083ee67beea1d0167bf3b78d6078e\"}],\"id\":\"2c9083ee67beea1d0167bf3b78d6078d\"},{\"order\":\"3\",\"defaultValue\":\"~\",\"value\":\"~\",\"itemType\":\"LABEL\",\"manageStyle\":\"NAME\",\"independent\":\"false\",\"id\":\"2c9083ee67beea1d0167bf3b78d6078f\"}],\"id\":\"2c9083ee67beea1d0167bf3b78d6078c\"}],\"id\":\"2c9083ee67beea1d0167bf3b78d50783\",\"whens\":{\"vype\":\"ONE_DIM_SPHERE\",\"sype\":\"SLICE_CASEWHEN\",\"position\":\"SDR_234G_FLOW_BASE_USER_MONTH#ff8080815f0047d2015f053598f00137#532#155@DIM_TIME_DATE#basic_calendar#268#283@CEA_USER_PROFILE_99997#basic_user#681#288\",\"template\":\"0\",\"options\":\"{\\\"highColor\\\":\\\"138,42,226,1\\\",\\\"normalColor\\\":\\\"159,170,183,1\\\"}\",\"buildSeting\":false,\"customSql\":\"SELECT STARTTIME,MSISDN,SUM( VOLUMN_2G ) AS VOLUMN_2G ,SUM( VOLUMN_3G ) AS VOLUMN_3G ,SUM( VOLUMN_4G ) AS VOLUMN_4G FROM SDR_234G_FLOW_BASE_USER_MONTH GROUP BY STARTTIME,MSISDN\",\"fields\":[{\"id\":\"2c9083ee67beea1d0167bf3b78e00796\",\"order\":0,\"sort\":\"DESC\",\"sqlOrder\":\"0\",\"xcase\":{\"whens\":[{\"order\":0,\"whenCmpts\":[{\"order\":0,\"union\":\"AND\",\"left\":{\"id\":\"4028819b67c96aeb0167c9b1502104e6\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78cb0773\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053b9b230142\",\"name\":\"VOLUMN_2G\",\"label\":\"VOLUMN_2G\",\"labelUS\":\"VOLUMN_2G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\"+\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b1506804eb\",\"drill\":{\"order\":0,\"left\":{\"id\":\"4028819b67c96aeb0167c9b1504004e7\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78cb0775\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053bc7990143\",\"name\":\"VOLUMN_3G\",\"label\":\"VOLUMN_3G\",\"labelUS\":\"VOLUMN_3G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\"+\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b1506804ea\",\"drill\":{\"order\":0,\"left\":{\"id\":\"4028819b67c96aeb0167c9b1506204e8\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78cc0777\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053bf0c50144\",\"name\":\"VOLUMN_4G\",\"label\":\"VOLUMN_4G\",\"labelUS\":\"VOLUMN_4G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\">=\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b1506204e9\",\"variable\":\"${qsz090}\",\"checkeIdStr\":\"qsz090\",\"type\":\"STR\"},\"id\":\"2c9083ee67beea1d0167bf3b78cc077a\"},\"drillBracket\":false,\"type\":\"DRILL\"},\"id\":\"2c9083ee67beea1d0167bf3b78cc077c\"},\"drillBracket\":false,\"type\":\"DRILL\"},\"id\":\"2c9083ee67beea1d0167bf3b78cc077e\"}],\"thenCmpts\":[{\"order\":0,\"union\":\"AND\",\"left\":{\"id\":\"4028819b67c96aeb0167c9b1507a04ec\",\"variable\":\"Traffic 234G\",\"prefix\":\"'\",\"type\":\"STR\"},\"operator\":\">=\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b1507a04ed\",\"variable\":\"${qsz090}\",\"checkeIdStr\":\"qsz090\",\"suffix\":\"MB'\",\"type\":\"STR\"},\"id\":\"2c9083ee67beea1d0167bf3b78cd0781\"}],\"id\":\"2c9083ee67beea1d0167bf3b78cb0772\"}],\"label\":\"Traffic 234G\",\"labelUS\":\"Traffic 234G\",\"id\":\"yhvnzn3931020103\"},\"type\":\"CASE\"},{\"id\":\"2c9083ee67beea1d0167bf3b78e00795\",\"order\":1,\"sort\":\"DESC\",\"sqlOrder\":\"1\",\"filter\":{\"order\":0,\"union\":\"and\",\"filterType\":\"BASE\",\"self\":false,\"dim\":false,\"isValid\":true,\"fixedId\":\"2c9083ee67c012700167c0136717013d\",\"isCurrentItem\":false,\"field\":{\"id\":\"2c9083ee67c012700167c0136717013c\",\"order\":0,\"xcase\":{\"whens\":[{\"order\":0,\"whenCmpts\":[{\"order\":0,\"union\":\"AND\",\"left\":{\"id\":\"4028819b67c96aeb0167c9b15515051c\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78c80763\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053b9b230142\",\"name\":\"VOLUMN_2G\",\"label\":\"VOLUMN_2G\",\"labelUS\":\"VOLUMN_2G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\"+\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b155550521\",\"drill\":{\"order\":0,\"left\":{\"id\":\"4028819b67c96aeb0167c9b15532051d\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78c90765\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053bc7990143\",\"name\":\"VOLUMN_3G\",\"label\":\"VOLUMN_3G\",\"labelUS\":\"VOLUMN_3G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\"+\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b155550520\",\"drill\":{\"order\":0,\"left\":{\"id\":\"4028819b67c96aeb0167c9b1554d051e\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78c90767\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053bf0c50144\",\"name\":\"VOLUMN_4G\",\"label\":\"VOLUMN_4G\",\"labelUS\":\"VOLUMN_4G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\">=\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b1554d051f\",\"variable\":\"${qsz090}\",\"checkeIdStr\":\"qsz090\",\"type\":\"STR\"},\"id\":\"2c9083ee67beea1d0167bf3b78c9076a\"},\"drillBracket\":false,\"type\":\"DRILL\"},\"id\":\"2c9083ee67beea1d0167bf3b78c9076c\"},\"drillBracket\":false,\"type\":\"DRILL\"},\"id\":\"2c9083ee67beea1d0167bf3b78ca076e\"}],\"thenCmpts\":[{\"order\":0,\"union\":\"AND\",\"left\":{\"id\":\"4028819b67c96aeb0167c9b155680522\",\"variable\":\"Traffic 234G\",\"prefix\":\"'\",\"type\":\"STR\"},\"operator\":\">=\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b155680523\",\"variable\":\"${qsz090}\",\"checkeIdStr\":\"qsz090\",\"suffix\":\"MB'\",\"type\":\"STR\"},\"id\":\"2c9083ee67beea1d0167bf3b78ca0771\"}],\"id\":\"2c9083ee67beea1d0167bf3b78c80762\"}],\"label\":\"Traffic 234G\",\"labelUS\":\"Traffic 234G\",\"id\":\"lanmjqrallwibqtl5535549669873710\"},\"type\":\"CASE\"},\"value\":\"${CASE_WHEN_SLICE_TEMPLATE}\",\"id\":\"2c9083ee67c012700167c0136717013d\",\"operator\":\"=\"},\"xcase\":{\"whens\":[{\"order\":0,\"whenCmpts\":[{\"order\":0,\"union\":\"AND\",\"left\":{\"id\":\"4028819b67c96aeb0167c9b15515051c\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78c80763\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053b9b230142\",\"name\":\"VOLUMN_2G\",\"label\":\"VOLUMN_2G\",\"labelUS\":\"VOLUMN_2G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\"+\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b155550521\",\"drill\":{\"order\":0,\"left\":{\"id\":\"4028819b67c96aeb0167c9b15532051d\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78c90765\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053bc7990143\",\"name\":\"VOLUMN_3G\",\"label\":\"VOLUMN_3G\",\"labelUS\":\"VOLUMN_3G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\"+\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b155550520\",\"drill\":{\"order\":0,\"left\":{\"id\":\"4028819b67c96aeb0167c9b1554d051e\",\"field\":{\"id\":\"2c9083ee67beea1d0167bf3b78c90767\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f053bf0c50144\",\"name\":\"VOLUMN_4G\",\"label\":\"VOLUMN_4G\",\"labelUS\":\"VOLUMN_4G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"type\":\"FIELD\"},\"operator\":\">=\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b1554d051f\",\"variable\":\"${qsz090}\",\"checkeIdStr\":\"qsz090\",\"type\":\"STR\"},\"id\":\"2c9083ee67beea1d0167bf3b78c9076a\"},\"drillBracket\":false,\"type\":\"DRILL\"},\"id\":\"2c9083ee67beea1d0167bf3b78c9076c\"},\"drillBracket\":false,\"type\":\"DRILL\"},\"id\":\"2c9083ee67beea1d0167bf3b78ca076e\"}],\"thenCmpts\":[{\"order\":0,\"union\":\"AND\",\"left\":{\"id\":\"4028819b67c96aeb0167c9b155680522\",\"variable\":\"Traffic 234G\",\"prefix\":\"'\",\"type\":\"STR\"},\"operator\":\">=\",\"right\":{\"id\":\"4028819b67c96aeb0167c9b155680523\",\"variable\":\"${qsz090}\",\"checkeIdStr\":\"qsz090\",\"suffix\":\"MB'\",\"type\":\"STR\"},\"id\":\"2c9083ee67beea1d0167bf3b78ca0771\"}],\"id\":\"2c9083ee67beea1d0167bf3b78c80762\"}],\"label\":\"Traffic 234G\",\"labelUS\":\"Traffic 234G\",\"id\":\"lanmjqrallwibqtl5535549669873710\"},\"type\":\"CASE\"}],\"stats\":[{\"id\":\"2c9083ee67beea1d0167bf3b78e00797\",\"order\":2,\"sort\":\"DESC\",\"sqlOrder\":\"2\",\"func\":\"COUNT\",\"duplicate\":\"true\",\"ref\":{\"id\":\"ff8080815f0047d2015f0537357b013a\",\"name\":\"MSISDN\",\"label\":\"MSISDN\",\"labelUS\":\"MSISDN\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"}],\"joins\":[{\"order\":0,\"type\":\"INNER\",\"left\":{\"id\":\"2c9083ee67beea1d0167bf3b78e1079c\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f0537357b013a\",\"name\":\"MSISDN\",\"label\":\"MSISDN\",\"labelUS\":\"MSISDN\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"right\":{\"id\":\"2c9083ee67beea1d0167bf3b78e1079d\",\"order\":0,\"ref\":{\"id\":\"basic_user_1\",\"name\":\"MSISDN\",\"label\":\"电话号码\",\"labelUS\":\"MSISDN\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"basic_user\",\"isDel\":\"0\",\"labelUS\":\"CEA_USER_PROFILE_99997\",\"label\":\"CEA_USER_PROFILE_99997\",\"type\":\"BASIC\",\"isDynamicName\":\"1\",\"name\":\"CEA_USER_PROFILE_99997\"}},\"type\":\"COLUMN\"},\"id\":\"2c9083ee67beea1d0167bf3b78e1079e\"},{\"order\":0,\"type\":\"INNER\",\"left\":{\"id\":\"2c9083ee67beea1d0167bf3b78e00799\",\"order\":0,\"ref\":{\"id\":\"ff8080815f0047d2015f0537056d0139\",\"name\":\"STARTTIME\",\"label\":\"STARTTIME\",\"labelUS\":\"STARTTIME\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}},\"type\":\"COLUMN\"},\"right\":{\"id\":\"2c9083ee67beea1d0167bf3b78e1079a\",\"order\":0,\"ref\":{\"id\":\"basic_calendar_1\",\"name\":\"STARTTIME_ID\",\"label\":\"STARTTIME_ID\",\"labelUS\":\"STARTTIME ID\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"basic_calendar\",\"isDel\":\"0\",\"labelUS\":\"DIM_TIME_DATE\",\"label\":\"DIM_TIME_DATE\",\"type\":\"BASIC\",\"isDynamicName\":\"1\",\"name\":\"DIM_TIME_DATE\"}},\"type\":\"COLUMN\"},\"id\":\"2c9083ee67beea1d0167bf3b78e1079b\"}],\"multiIndexs\":[{\"id\":\"2c9083ee67beea1d0167bf3b78e00798\"}],\"id\":\"2c9083ee67beea1d0167bf37f6fe0741\"}}],\"id\":\"2c9083ee67beea1d0167bf3b78d50782\"}],\"detail\":{\"id\":\"2c9083ee67beea1d0167bf431e030817\",\"fields\":[{\"id\":\"4028819b680c7e2401680d720d2c029f\",\"selected\":\"true\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"2c9083ee680d546701680d5c34f40014\",\"name\":\"L2REGIONNAME\",\"label\":\"L2REGIONNAME\",\"labelUS\":\"L2REGIONNAME\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"2c9083ee680d546701680d55c991000c\",\"isDel\":\"0\",\"labelUS\":\"DIM_REGION\",\"label\":\"DIM_REGION\",\"type\":\"DIM\",\"isDynamicName\":\"1\",\"name\":\"DIM_REGION\"}}},{\"id\":\"4028819b680c7e2401680d720d3702a0\",\"selected\":\"true\",\"order\":1,\"type\":\"COLUMN\",\"ref\":{\"id\":\"2c9083ee680d546701680d5c661f0015\",\"name\":\"L3REGIONNAME\",\"label\":\"L3REGIONNAME\",\"labelUS\":\"L3REGIONNAME\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"2c9083ee680d546701680d55c991000c\",\"isDel\":\"0\",\"labelUS\":\"DIM_REGION\",\"label\":\"DIM_REGION\",\"type\":\"DIM\",\"isDynamicName\":\"1\",\"name\":\"DIM_REGION\"}},\"salt\":\"laalnw298299\"},{\"id\":\"2c9083ee67beea1d0167bf431e04081b\",\"selected\":\"true\",\"order\":2,\"type\":\"COLUMN\",\"ref\":{\"id\":\"ff8080815f0047d2015f0537357b013a\",\"name\":\"MSISDN\",\"label\":\"MSISDN\",\"labelUS\":\"MSISDN\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},{\"id\":\"2c9083ee67beea1d0167bf431e04081a\",\"selected\":\"true\",\"order\":3,\"type\":\"COLUMN\",\"ref\":{\"id\":\"ff8080815f0047d2015f053b9b230142\",\"name\":\"VOLUMN_2G\",\"label\":\"VOLUMN_2G\",\"labelUS\":\"VOLUMN_2G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},{\"id\":\"2c9083ee67beea1d0167bf431e030819\",\"selected\":\"true\",\"order\":4,\"type\":\"COLUMN\",\"ref\":{\"id\":\"ff8080815f0047d2015f053bc7990143\",\"name\":\"VOLUMN_3G\",\"label\":\"VOLUMN_3G\",\"labelUS\":\"VOLUMN_3G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},{\"id\":\"2c9083ee67beea1d0167bf431e030818\",\"selected\":\"true\",\"order\":5,\"type\":\"COLUMN\",\"ref\":{\"id\":\"ff8080815f0047d2015f053bf0c50144\",\"name\":\"VOLUMN_4G\",\"label\":\"VOLUMN_4G\",\"labelUS\":\"VOLUMN_4G\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}}],\"stats\":[{\"id\":\"2c9083ee67beea1d0167bf431e04081c\",\"eval\":\"VOLUMN_2G+VOLUMN_3G\",\"order\":6,\"type\":\"EVAL\"},{\"id\":\"2c9083ee67beea1d0167bf431e04081d\",\"eval\":\"VOLUMN_2G+VOLUMN_3G+VOLUMN_4G\",\"order\":7,\"type\":\"EVAL\"}],\"joins\":[{\"id\":\"4028819b680c7e2401680d720d6a02a3\",\"type\":\"INNER\",\"order\":0,\"left\":{\"id\":\"4028819b680c7e2401680d720d6902a1\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"4028819b67d57a4f0167d5b18ed00344\",\"name\":\"LAYER2ID\",\"label\":\"LAYER2ID\",\"labelUS\":\"LAYER2ID\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},\"right\":{\"id\":\"4028819b680c7e2401680d720d6a02a2\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"2c9083ee680d546701680d5aed08000e\",\"name\":\"L2REGIONID\",\"label\":\"L2REGIONID\",\"labelUS\":\"L2REGIONID\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"2c9083ee680d546701680d55c991000c\",\"isDel\":\"0\",\"labelUS\":\"DIM_REGION\",\"label\":\"DIM_REGION\",\"type\":\"DIM\",\"isDynamicName\":\"1\",\"name\":\"DIM_REGION\"}}}},{\"id\":\"4028819b680c7e2401680d720d6a02a6\",\"type\":\"INNER\",\"order\":0,\"left\":{\"id\":\"4028819b680c7e2401680d720d6a02a4\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"4028819b67d57a4f0167d5b1b6ab0345\",\"name\":\"LAYER3ID\",\"label\":\"LAYER3ID\",\"labelUS\":\"LAYER3ID\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},\"right\":{\"id\":\"4028819b680c7e2401680d720d6a02a5\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"2c9083ee680d546701680d5b264f000f\",\"name\":\"L3REGIONID\",\"label\":\"L3REGIONID\",\"labelUS\":\"L3REGIONID\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"2c9083ee680d546701680d55c991000c\",\"isDel\":\"0\",\"labelUS\":\"DIM_REGION\",\"label\":\"DIM_REGION\",\"type\":\"DIM\",\"isDynamicName\":\"1\",\"name\":\"DIM_REGION\"}},\"salt\":\"laalnw298299\"}},{\"id\":\"4028819b680c7e2401680d720d6b02a9\",\"type\":\"INNER\",\"order\":0,\"left\":{\"id\":\"4028819b680c7e2401680d720d6b02a7\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"ff8080815f0047d2015f0537056d0139\",\"name\":\"STARTTIME\",\"label\":\"STARTTIME\",\"labelUS\":\"STARTTIME\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},\"right\":{\"id\":\"4028819b680c7e2401680d720d6b02a8\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"basic_calendar_1\",\"name\":\"STARTTIME_ID\",\"label\":\"STARTTIME_ID\",\"labelUS\":\"STARTTIME ID\",\"typeName\":\"NUMERIC\",\"isDel\":\"0\",\"type\":\"2\",\"table\":{\"id\":\"basic_calendar\",\"isDel\":\"0\",\"labelUS\":\"DIM_TIME_DATE\",\"label\":\"DIM_TIME_DATE\",\"type\":\"BASIC\",\"isDynamicName\":\"1\",\"name\":\"DIM_TIME_DATE\"}}}},{\"id\":\"4028819b680c7e2401680d720d6c02ac\",\"type\":\"INNER\",\"order\":0,\"left\":{\"id\":\"4028819b680c7e2401680d720d6b02aa\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"ff8080815f0047d2015f0537357b013a\",\"name\":\"MSISDN\",\"label\":\"MSISDN\",\"labelUS\":\"MSISDN\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"ff8080815f0047d2015f053598f00137\",\"isDel\":\"0\",\"labelUS\":\"sdr_234g_month\",\"label\":\"sdr_234g_month\",\"type\":\"DATA\",\"isDynamicName\":\"0\",\"name\":\"SDR_234G_FLOW_BASE_USER_MONTH\"}}},\"right\":{\"id\":\"4028819b680c7e2401680d720d6b02ab\",\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"basic_user_1\",\"name\":\"MSISDN\",\"label\":\"电话号码\",\"labelUS\":\"MSISDN\",\"typeName\":\"VARCHAR\",\"isDel\":\"0\",\"type\":\"12\",\"table\":{\"id\":\"basic_user\",\"isDel\":\"0\",\"labelUS\":\"CEA_USER_PROFILE_99997\",\"label\":\"CEA_USER_PROFILE_99997\",\"type\":\"BASIC\",\"isDynamicName\":\"1\",\"name\":\"CEA_USER_PROFILE_99997\"}}}}]}}]},\"filter\":{\"order\":0,\"self\":false,\"isValid\":true,\"isCurrentItem\":false,\"dim\":false,\"filterType\":\"CALENDAR\",\"union\":\"AND\",\"field\":{\"order\":0,\"type\":\"COLUMN\",\"ref\":{\"id\":\"basic_calendar_4\",\"createdAt\":\"2019-01-24 04:23:42\",\"createdBy\":{\"id\":\"sys\",\"createdAt\":\"2019-01-24 03:56:24\",\"updatedAt\":\"2019-01-24 03:56:24\",\"name\":\"Sys\",\"email\":\"sys@huawei.com\",\"post\":\"boss\",\"avatar\":\"images/photo/diaphoto.png\"},\"name\":\"MONTH_ID\",\"label\":\"MONTH_ID\",\"labelUS\":\"MONTH_ID\",\"type\":2,\"typeName\":\"NUMERIC\",\"table\":{\"id\":\"basic_calendar\",\"createdAt\":\"2019-01-24 04:23:42\",\"createdBy\":{\"id\":\"sys\",\"createdAt\":\"2019-01-24 03:56:24\",\"updatedAt\":\"2019-01-24 03:56:24\",\"name\":\"Sys\",\"email\":\"sys@huawei.com\",\"post\":\"boss\",\"avatar\":\"images/photo/diaphoto.png\"},\"name\":\"DIM_TIME_DATE\",\"type\":\"BASIC\",\"label\":\"DIM_TIME_DATE\",\"labelUS\":\"DIM_TIME_DATE\",\"isDel\":0,\"isDynamicName\":1},\"isDel\":0}},\"operator\":\"=\",\"value\":\"201901\"}}},\"offset\":0,\"limit\":10,\"total\":0}";
	        String fileServiceUrl="http://192.168.1.45:3000/api/case/arrangement/analysis/exportcsv";
	        //发送请求，获取结果
	        String result = HttpUtils.doPost(fileServiceUrl , data);    
	        if(StringUtils.isNotBlank(result)){
	            com.alibaba.fastjson.JSONObject jsonobject = JSON.parseObject(result);
	            LOG.info("jsonobject = " + jsonobject);
	        }
		
		
	}

}
